{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {
    "collapsed": true
   },
   "outputs": [
    {
     "data": {
      "text/plain": "      Unnamed: 0                               call_id  cargo_tag  \\\n0              0  1200_10065_4294967295_20220318051943        NaN   \n1              1  1200_11098_4294967295_20220311061620        0.0   \n2              2  1200_12179_4294967295_20220317040558        NaN   \n3              6  1200_13054_4294967295_20220315085045        1.0   \n4              7  1200_13600_4294967295_20220310233749        1.0   \n...          ...                                   ...        ...   \n4357        5276    C20220321184734AC10211337372747722        1.0   \n4358        5278    C20220321192420AC10213873089458277        NaN   \n4359        5279    C20220321194013AC10212489428967413        1.0   \n4360        5280    C20220321201717AC10210147319396180        NaN   \n4361        5281    C20220321213243AC10212119802075706        NaN   \n\n              reason        cargo_id     driver_id    shipper_id  \\\n0     词正确,无法确定货物为危化品  32521072806820  4.000000e+18  4.000000e+18   \n1          词正确,用户仅聊到  32365123634609  4.000000e+18  9.631527e+16   \n2         语音或者文本,听不懂  32500752496255  9.643639e+16  9.643639e+16   \n3             确认是违禁品  32456534982123  4.000000e+18  9.643639e+16   \n4             确认是违禁品  32344565815754  4.000000e+18  6.006085e+17   \n...              ...             ...           ...           ...   \n4357          确认是违禁品  32589118659324  4.000000e+18  4.000000e+18   \n4358       词正确,用户仅聊到  32591569841004  6.006085e+17  3.988217e+18   \n4359          确认是违禁品  32587075983735  1.509019e+16  3.988217e+18   \n4360  词正确,无法确定货物为危化品  32586434182120  4.000000e+18  4.000000e+18   \n4361       词正确,用户仅聊到  32590235179525  4.000000e+18  4.000000e+18   \n\n                                      airequest_content sure_contraband  \\\n0     {\"dialogue\":[[\"S:喂。\",\"D:喂，你好。\",\"S:啊。\",\"D:有个货去武...              汽油   \n1     {\"dialogue\":[[\"D:喂喂，哎你好。\",\"S:哎。\",\"S:啊。\",\"D:啊，你...              胶水   \n2     {\"dialogue\":[[\"S:哎。\",\"D:a多长乡西的这个这个给多钱呀？\",\"S:什么...              垃圾   \n3     {\"dialogue\":[[\"D:喂喂。\",\"S:嗯。\",\"D:喂。\",\"S:你说。\",\"D...             废钢筋   \n4     {\"dialogue\":[[\"S:哎。\",\"D:喂，你好。\",\"S:啊。\",\"D:那个废铁。...              垃圾   \n...                                                 ...             ...   \n4357  {\"dialogue\":[[\"S:你好。\",\"D:啊，老板。\",\"S:啊。\",\"D:啊这个。...              硅铁   \n4358  {\"dialogue\":[[\"D:哎，你好。\",\"S:喂，你好嗯。\",\"D:啊，到那个二那个...             活性炭   \n4359  {\"dialogue\":[[\"D:哎。\",\"S:a。\",\"D:哎，老板这几个配件就是这几个五...              烟叶   \n4360  {\"dialogue\":[[\"S:喂。\",\"D:哎，你好。\",\"S:啊，哪里呀？\",\"D:你...              木屑   \n4361  {\"dialogue\":[[\"D:哎。\",\"S:哎，你好。\",\"D:你好，你那个油瓶是个什么...             植物油   \n\n                                             airesponse new_contraband  \n0     {\"contraband_infos\":[{\"not_sure_contraband\":[]...             汽油  \n1     {\"contraband_infos\":[{\"not_sure_contraband\":[]...             胶水  \n2     {\"contraband_infos\":[{\"not_sure_contraband\":[]...             垃圾  \n3     {\"contraband_infos\":[{\"not_sure_contraband\":[]...            废钢筋  \n4     {\"contraband_infos\":[{\"not_sure_contraband\":[]...             垃圾  \n...                                                 ...            ...  \n4357  {\"contraband_infos\":[{\"not_sure_contraband\":[]...             硅铁  \n4358  {\"contraband_infos\":[{\"not_sure_contraband\":[]...            活性炭  \n4359  {\"contraband_infos\":[{\"not_sure_contraband\":[]...             烟叶  \n4360  {\"contraband_infos\":[{\"not_sure_contraband\":[]...             木屑  \n4361  {\"contraband_infos\":[{\"not_sure_contraband\":[]...            植物油  \n\n[4362 rows x 11 columns]",
      "text/html": "<div>\n<style scoped>\n    .dataframe tbody tr th:only-of-type {\n        vertical-align: middle;\n    }\n\n    .dataframe tbody tr th {\n        vertical-align: top;\n    }\n\n    .dataframe thead th {\n        text-align: right;\n    }\n</style>\n<table border=\"1\" class=\"dataframe\">\n  <thead>\n    <tr style=\"text-align: right;\">\n      <th></th>\n      <th>Unnamed: 0</th>\n      <th>call_id</th>\n      <th>cargo_tag</th>\n      <th>reason</th>\n      <th>cargo_id</th>\n      <th>driver_id</th>\n      <th>shipper_id</th>\n      <th>airequest_content</th>\n      <th>sure_contraband</th>\n      <th>airesponse</th>\n      <th>new_contraband</th>\n    </tr>\n  </thead>\n  <tbody>\n    <tr>\n      <th>0</th>\n      <td>0</td>\n      <td>1200_10065_4294967295_20220318051943</td>\n      <td>NaN</td>\n      <td>词正确,无法确定货物为危化品</td>\n      <td>32521072806820</td>\n      <td>4.000000e+18</td>\n      <td>4.000000e+18</td>\n      <td>{\"dialogue\":[[\"S:喂。\",\"D:喂，你好。\",\"S:啊。\",\"D:有个货去武...</td>\n      <td>汽油</td>\n      <td>{\"contraband_infos\":[{\"not_sure_contraband\":[]...</td>\n      <td>汽油</td>\n    </tr>\n    <tr>\n      <th>1</th>\n      <td>1</td>\n      <td>1200_11098_4294967295_20220311061620</td>\n      <td>0.0</td>\n      <td>词正确,用户仅聊到</td>\n      <td>32365123634609</td>\n      <td>4.000000e+18</td>\n      <td>9.631527e+16</td>\n      <td>{\"dialogue\":[[\"D:喂喂，哎你好。\",\"S:哎。\",\"S:啊。\",\"D:啊，你...</td>\n      <td>胶水</td>\n      <td>{\"contraband_infos\":[{\"not_sure_contraband\":[]...</td>\n      <td>胶水</td>\n    </tr>\n    <tr>\n      <th>2</th>\n      <td>2</td>\n      <td>1200_12179_4294967295_20220317040558</td>\n      <td>NaN</td>\n      <td>语音或者文本,听不懂</td>\n      <td>32500752496255</td>\n      <td>9.643639e+16</td>\n      <td>9.643639e+16</td>\n      <td>{\"dialogue\":[[\"S:哎。\",\"D:a多长乡西的这个这个给多钱呀？\",\"S:什么...</td>\n      <td>垃圾</td>\n      <td>{\"contraband_infos\":[{\"not_sure_contraband\":[]...</td>\n      <td>垃圾</td>\n    </tr>\n    <tr>\n      <th>3</th>\n      <td>6</td>\n      <td>1200_13054_4294967295_20220315085045</td>\n      <td>1.0</td>\n      <td>确认是违禁品</td>\n      <td>32456534982123</td>\n      <td>4.000000e+18</td>\n      <td>9.643639e+16</td>\n      <td>{\"dialogue\":[[\"D:喂喂。\",\"S:嗯。\",\"D:喂。\",\"S:你说。\",\"D...</td>\n      <td>废钢筋</td>\n      <td>{\"contraband_infos\":[{\"not_sure_contraband\":[]...</td>\n      <td>废钢筋</td>\n    </tr>\n    <tr>\n      <th>4</th>\n      <td>7</td>\n      <td>1200_13600_4294967295_20220310233749</td>\n      <td>1.0</td>\n      <td>确认是违禁品</td>\n      <td>32344565815754</td>\n      <td>4.000000e+18</td>\n      <td>6.006085e+17</td>\n      <td>{\"dialogue\":[[\"S:哎。\",\"D:喂，你好。\",\"S:啊。\",\"D:那个废铁。...</td>\n      <td>垃圾</td>\n      <td>{\"contraband_infos\":[{\"not_sure_contraband\":[]...</td>\n      <td>垃圾</td>\n    </tr>\n    <tr>\n      <th>...</th>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n    </tr>\n    <tr>\n      <th>4357</th>\n      <td>5276</td>\n      <td>C20220321184734AC10211337372747722</td>\n      <td>1.0</td>\n      <td>确认是违禁品</td>\n      <td>32589118659324</td>\n      <td>4.000000e+18</td>\n      <td>4.000000e+18</td>\n      <td>{\"dialogue\":[[\"S:你好。\",\"D:啊，老板。\",\"S:啊。\",\"D:啊这个。...</td>\n      <td>硅铁</td>\n      <td>{\"contraband_infos\":[{\"not_sure_contraband\":[]...</td>\n      <td>硅铁</td>\n    </tr>\n    <tr>\n      <th>4358</th>\n      <td>5278</td>\n      <td>C20220321192420AC10213873089458277</td>\n      <td>NaN</td>\n      <td>词正确,用户仅聊到</td>\n      <td>32591569841004</td>\n      <td>6.006085e+17</td>\n      <td>3.988217e+18</td>\n      <td>{\"dialogue\":[[\"D:哎，你好。\",\"S:喂，你好嗯。\",\"D:啊，到那个二那个...</td>\n      <td>活性炭</td>\n      <td>{\"contraband_infos\":[{\"not_sure_contraband\":[]...</td>\n      <td>活性炭</td>\n    </tr>\n    <tr>\n      <th>4359</th>\n      <td>5279</td>\n      <td>C20220321194013AC10212489428967413</td>\n      <td>1.0</td>\n      <td>确认是违禁品</td>\n      <td>32587075983735</td>\n      <td>1.509019e+16</td>\n      <td>3.988217e+18</td>\n      <td>{\"dialogue\":[[\"D:哎。\",\"S:a。\",\"D:哎，老板这几个配件就是这几个五...</td>\n      <td>烟叶</td>\n      <td>{\"contraband_infos\":[{\"not_sure_contraband\":[]...</td>\n      <td>烟叶</td>\n    </tr>\n    <tr>\n      <th>4360</th>\n      <td>5280</td>\n      <td>C20220321201717AC10210147319396180</td>\n      <td>NaN</td>\n      <td>词正确,无法确定货物为危化品</td>\n      <td>32586434182120</td>\n      <td>4.000000e+18</td>\n      <td>4.000000e+18</td>\n      <td>{\"dialogue\":[[\"S:喂。\",\"D:哎，你好。\",\"S:啊，哪里呀？\",\"D:你...</td>\n      <td>木屑</td>\n      <td>{\"contraband_infos\":[{\"not_sure_contraband\":[]...</td>\n      <td>木屑</td>\n    </tr>\n    <tr>\n      <th>4361</th>\n      <td>5281</td>\n      <td>C20220321213243AC10212119802075706</td>\n      <td>NaN</td>\n      <td>词正确,用户仅聊到</td>\n      <td>32590235179525</td>\n      <td>4.000000e+18</td>\n      <td>4.000000e+18</td>\n      <td>{\"dialogue\":[[\"D:哎。\",\"S:哎，你好。\",\"D:你好，你那个油瓶是个什么...</td>\n      <td>植物油</td>\n      <td>{\"contraband_infos\":[{\"not_sure_contraband\":[]...</td>\n      <td>植物油</td>\n    </tr>\n  </tbody>\n</table>\n<p>4362 rows × 11 columns</p>\n</div>"
     },
     "execution_count": 1,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "import pandas as pd\n",
    "data = \"风控结果3月11日开始.xlsx\"\n",
    "df = pd.read_excel(data)\n",
    "df\n"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 2
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython2",
   "version": "2.7.6"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 0
}